Pandas Profiling Report

Dataset statistics

Number of variables	30
Number of observations	1563215
Missing cells	1827272
Missing cells (%)	3.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	357.8 MiB
Average record size in memory	240.0 B

Variable types

Numeric	11
Categorical	18
Boolean	1

Alerts

`WORK GROUP` has a high cardinality: 146 distinct values	High cardinality
`REQUEST TYPE` has a high cardinality: 1236 distinct values	High cardinality
`CATEGORY` has a high cardinality: 84 distinct values	High cardinality
`TYPE` has a high cardinality: 295 distinct values	High cardinality
`DETAIL` has a high cardinality: 574 distinct values	High cardinality
`CREATION DATE` has a high cardinality: 5229 distinct values	High cardinality
`CREATION TIME` has a high cardinality: 1440 distinct values	High cardinality
`CLOSED DATE` has a high cardinality: 4995 distinct values	High cardinality
`STREET ADDRESS` has a high cardinality: 277728 distinct values	High cardinality
`ADDRESS WITH GEOCODE` has a high cardinality: 307249 distinct values	High cardinality
`NEIGHBORHOOD` has a high cardinality: 250 distinct values	High cardinality
`CASE URL` has a high cardinality: 1563215 distinct values	High cardinality
`SOURCE` is highly imbalanced (72.5%)	Imbalance
`DEPARTMENT` is highly imbalanced (55.9%)	Imbalance
`STATUS` is highly imbalanced (94.2%)	Imbalance
`COUNTY` is highly imbalanced (74.4%)	Imbalance
`CLOSED MONTH` has 26515 (1.7%) missing values	Missing
`CLOSED YEAR` has 26515 (1.7%) missing values	Missing
`DAYS TO CLOSE` has 26515 (1.7%) missing values	Missing
`NEIGHBORHOOD` has 46106 (2.9%) missing values	Missing
`COUNTY` has 66959 (4.3%) missing values	Missing
`COUNCIL DISTRICT` has 35242 (2.3%) missing values	Missing
`POLICE DISTRICT` has 35265 (2.3%) missing values	Missing
`30-60-90 Days Open Window` has 1550513 (99.2%) missing values	Missing
`ZIP CODE` is highly skewed (γ1 = -832.06849)	Skewed
`PARCEL ID NO` is highly skewed (γ1 = 250.9088658)	Skewed
`CASE URL` is uniformly distributed	Uniform
`CASE ID` has unique values	Unique
`CASE URL` has unique values	Unique
`DAYS TO CLOSE` has 150614 (9.6%) zeros	Zeros
`PARCEL ID NO` has 35266 (2.3%) zeros	Zeros

Reproduction

Analysis started	2023-02-25 15:09:55.053730
Analysis finished	2023-02-25 15:12:13.662627
Duration	2 minutes and 18.61 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

CASE ID
Real number (ℝ)

Distinct	1563215
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0140133 × 10⁹

Minimum	2.006 × 10⁹
Maximum	2.0210337 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	2.006 × 10⁹
5-th percentile	2.0071832 × 10⁹
Q1	2.0101856 × 10⁹
median	2.0140975 × 10⁹
Q3	2.0180632 × 10⁹
95-th percentile	2.0200896 × 10⁹
Maximum	2.0210337 × 10⁹
Range	15033684
Interquartile range (IQR)	7877594

Descriptive statistics

Standard deviation	4222588.7
Coefficient of variation (CV)	0.0020966042
Kurtosis	-1.3391166
Mean	2.0140133 × 10⁹
Median Absolute Deviation (MAD)	3950638
Skewness	-0.072037995
Sum	3.1483358 × 10¹⁵
Variance	1.7830256 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2019119972	1	< 0.1%
2015045877	1	< 0.1%
2015040302	1	< 0.1%
2015041682	1	< 0.1%
2015049038	1	< 0.1%
2015034811	1	< 0.1%
2015041579	1	< 0.1%
2015042453	1	< 0.1%
2015052481	1	< 0.1%
2015043953	1	< 0.1%
Other values (1563205)	1563205	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2006000002	1	< 0.1%
2006000004	1	< 0.1%
2007000001	1	< 0.1%
2007000005	1	< 0.1%
2007000009	1	< 0.1%
2007000010	1	< 0.1%
2007000012	1	< 0.1%
2007000013	1	< 0.1%
2007000014	1	< 0.1%
2007000015	1	< 0.1%

Value	Count	Frequency (%)
2021033686	1	< 0.1%
2021033407	1	< 0.1%
2021033233	1	< 0.1%
2021033140	1	< 0.1%
2021032869	1	< 0.1%
2021032828	1	< 0.1%
2021032612	1	< 0.1%
2021032575	1	< 0.1%
2021032525	1	< 0.1%
2021032480	1	< 0.1%

SOURCE
Categorical

Distinct	21
Distinct (%)	< 0.1%
Missing	67
Missing (%)	< 0.1%
Memory size	11.9 MiB

PHONE	1204236
WEB	211721
EMAIL	80585
SYS	19226
INSPE	14690
Other values (16)	32690

Length

Max length	5
Median length	5
Mean length	4.677877
Min length	3

Characters and Unicode

Total characters	7312214
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PHONE
2nd row	WEB
3rd row	PHONE
4th row	PHONE
5th row	WEB

Common Values

Value	Count	Frequency (%)
PHONE	1204236	77.0%
WEB	211721	13.5%
EMAIL	80585	5.2%
SYS	19226	1.2%
INSPE	14690	0.9%
BOT	13396	0.9%
TWIR	8311	0.5%
VOICE	6021	0.4%
WALK	1792	0.1%
FAX	1538	0.1%
Other values (11)	1632	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
phone	1204236	77.0%
web	211721	13.5%
email	80585	5.2%
sys	19226	1.2%
inspe	14690	0.9%
bot	13396	0.9%
twir	8311	0.5%
voice	6021	0.4%
walk	1792	0.1%
fax	1538	0.1%
Other values (11)	1632	0.1%

Most occurring characters

Value	Count	Frequency (%)
E	1518427	20.8%
O	1223712	16.7%
P	1219913	16.7%
N	1218950	16.7%
H	1204260	16.5%
B	225129	3.1%
W	221824	3.0%
I	110312	1.5%
A	84238	1.2%
L	82700	1.1%
Other values (12)	202749	2.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7312214	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1518427	20.8%
O	1223712	16.7%
P	1219913	16.7%
N	1218950	16.7%
H	1204260	16.5%
B	225129	3.1%
W	221824	3.0%
I	110312	1.5%
A	84238	1.2%
L	82700	1.1%
Other values (12)	202749	2.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7312214	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1518427	20.8%
O	1223712	16.7%
P	1219913	16.7%
N	1218950	16.7%
H	1204260	16.5%
B	225129	3.1%
W	221824	3.0%
I	110312	1.5%
A	84238	1.2%
L	82700	1.1%
Other values (12)	202749	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7312214	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	1518427	20.8%
O	1223712	16.7%
P	1219913	16.7%
N	1218950	16.7%
H	1204260	16.5%
B	225129	3.1%
W	221824	3.0%
I	110312	1.5%
A	84238	1.2%
L	82700	1.1%
Other values (12)	202749	2.8%

DEPARTMENT
Categorical

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

NHS	783094
Public Works	353787
Water Services	216852
Parks and Rec	87954
Health	39543
Other values (22)	81985

Length

Max length	35
Median length	3
Mean length	7.6318446
Min length	2

Characters and Unicode

Total characters	11930214
Distinct characters	40
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	NHS
2nd row	Public Works
3rd row	NHS
4th row	NHS
5th row	Parks and Rec

Common Values

Value	Count	Frequency (%)
NHS	783094	50.1%
Public Works	353787	22.6%
Water Services	216852	13.9%
Parks and Rec	87954	5.6%
Health	39543	2.5%
KCPD	36369	2.3%
City Managers Office	13098	0.8%
City Planning and Development	12575	0.8%
Northland	8591	0.5%
NCS	6391	0.4%
Other values (17)	4961	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nhs	783094	32.9%
public	353787	14.9%
works	353787	14.9%
water	216852	9.1%
services	216852	9.1%
and	100588	4.2%
parks	88826	3.7%
rec	88815	3.7%
health	39543	1.7%
kcpd	36369	1.5%
Other values (32)	98741	4.2%

Most occurring characters

Value	Count	Frequency (%)
S	1007164	8.4%
r	900261	7.5%
e	847896	7.1%
H	822980	6.9%
	814039	6.8%
N	798111	6.7%
c	675143	5.7%
s	672981	5.6%
i	626675	5.3%
W	570639	4.8%
Other values (30)	4194325	35.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7151431	59.9%
Uppercase Letter	3963872	33.2%
Space Separator	814039	6.8%
Other Punctuation	872	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	900261	12.6%
e	847896	11.9%
c	675143	9.4%
s	672981	9.4%
i	626675	8.8%
a	496002	6.9%
k	442615	6.2%
l	427997	6.0%
o	376777	5.3%
u	355543	5.0%
Other values (11)	1329541	18.6%

Uppercase Letter

Value	Count	Frequency (%)
S	1007164	25.4%
H	822980	20.8%
N	798111	20.1%
W	570639	14.4%
P	491557	12.4%
R	88827	2.2%
C	69282	1.7%
D	49286	1.2%
K	36369	0.9%
M	13514	0.3%
Other values (7)	16143	0.4%

Space Separator

Value	Count	Frequency (%)
	814039	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	872	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11115303	93.2%
Common	814911	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	1007164	9.1%
r	900261	8.1%
e	847896	7.6%
H	822980	7.4%
N	798111	7.2%
c	675143	6.1%
s	672981	6.1%
i	626675	5.6%
W	570639	5.1%
a	496002	4.5%
Other values (28)	3697451	33.3%

Common

Value	Count	Frequency (%)
	814039	99.9%
&	872	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11930214	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	1007164	8.4%
r	900261	7.5%
e	847896	7.1%
H	822980	6.9%
	814039	6.8%
N	798111	6.7%
c	675143	5.7%
s	672981	5.6%
i	626675	5.3%
W	570639	4.8%
Other values (30)	4194325	35.2%

WORK GROUP
Categorical

Distinct	146
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

NHS-Neighborhood Preservation-	286049
NHS-Solid Waste-	238286
NHS-Animal Health and Safety-	136453
Public Works-Solid Waste-	99384
Water Services-Meter and Field Services-	88432
Other values (141)	714611

Length

Max length	50
Median length	47
Mean length	31.048004
Min length	6

Characters and Unicode

Total characters	48534706
Distinct characters	53
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	NHS-Dangerous Buildings-
2nd row	Public Works-Street and Traffic-District 1
3rd row	NHS-Dangerous Buildings-
4th row	NHS-Neighborhood Preservation-
5th row	Parks and Rec-Central Region-

Common Values

Value	Count	Frequency (%)
NHS-Neighborhood Preservation-	286049	18.3%
NHS-Solid Waste-	238286	15.2%
NHS-Animal Health and Safety-	136453	8.7%
Public Works-Solid Waste-	99384	6.4%
Water Services-Meter and Field Services-	88432	5.7%
Parks and Rec-Landscape Services-Forestry	65660	4.2%
NHS-Solid Waste-Administration	44450	2.8%
Public Works-Street and Traffic-District 3	40955	2.6%
Water Services-Line Maintenance-Wastewater	39641	2.5%
Public Works-Street and Traffic-Streetlights	38108	2.4%
Other values (136)	485797	31.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
and	497876	10.5%
public	353787	7.5%
waste	337776	7.2%
nhs-neighborhood	317500	6.7%
nhs-solid	299322	6.3%
preservation	286854	6.1%
water	216852	4.6%
works-street	159398	3.4%
health	143813	3.0%
nhs-animal	139749	3.0%
Other values (206)	1968123	41.7%

Most occurring characters

Value	Count	Frequency (%)
e	4530059	9.3%
i	3300515	6.8%
r	3283333	6.8%
a	3180184	6.6%
	3157835	6.5%
-	3121076	6.4%
t	2853937	5.9%
o	2635467	5.4%
s	2190723	4.5%
n	2099413	4.3%
Other values (43)	18182164	37.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	34166821	70.4%
Uppercase Letter	7973083	16.4%
Space Separator	3157835	6.5%
Dash Punctuation	3121076	6.4%
Decimal Number	114274	0.2%
Other Punctuation	1617	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4530059	13.3%
i	3300515	9.7%
r	3283333	9.6%
a	3180184	9.3%
t	2853937	8.4%
o	2635467	7.7%
s	2190723	6.4%
n	2099413	6.1%
l	1550002	4.5%
d	1511973	4.4%
Other values (14)	7031215	20.6%

Uppercase Letter

Value	Count	Frequency (%)
S	2058471	25.8%
N	1136393	14.3%
W	1020241	12.8%
P	1005647	12.6%
H	976676	12.2%
C	262046	3.3%
A	220751	2.8%
M	215408	2.7%
T	213447	2.7%
L	202835	2.5%
Other values (13)	661168	8.3%

Decimal Number

Value	Count	Frequency (%)
3	50862	44.5%
1	39053	34.2%
2	24359	21.3%

Space Separator

Value	Count	Frequency (%)
	3157835	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3121076	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	1617	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	42139904	86.8%
Common	6394802	13.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4530059	10.8%
i	3300515	7.8%
r	3283333	7.8%
a	3180184	7.5%
t	2853937	6.8%
o	2635467	6.3%
s	2190723	5.2%
n	2099413	5.0%
S	2058471	4.9%
l	1550002	3.7%
Other values (37)	14457800	34.3%

Common

Value	Count	Frequency (%)
	3157835	49.4%
-	3121076	48.8%
3	50862	0.8%
1	39053	0.6%
2	24359	0.4%
&	1617	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48534706	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	4530059	9.3%
i	3300515	6.8%
r	3283333	6.8%
a	3180184	6.6%
	3157835	6.5%
-	3121076	6.4%
t	2853937	5.9%
o	2635467	5.4%
s	2190723	4.5%
n	2099413	4.3%
Other values (43)	18182164	37.5%

REQUEST TYPE
Categorical

Distinct	1236
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

Property Violations	224533
Nuisance Violations	41386
Animal Control	34613
Water Leak or Pressure Problem	33054
Dead Animal Pick-up	28712
Other values (1231)	1200917

Length

Max length	80
Median length	67
Mean length	32.553566
Min length	7

Characters and Unicode

Total characters	50888223
Distinct characters	73
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	70 ?
Unique (%)	< 0.1%

Sample

1st row	Prop/Build/Construct-Dangerous Building-On list
2nd row	Streets / Roadways / Alleys-Crack-District 1
3rd row	Prop/Build/Construct-Dangerous Building-On list
4th row	Property Violations
5th row	Parks & Recreation-Park Maintenance-Central

Common Values

Value	Count	Frequency (%)
Property Violations	224533	14.4%
Nuisance Violations	41386	2.6%
Animal Control	34613	2.2%
Water Leak or Pressure Problem	33054	2.1%
Dead Animal Pick-up	28712	1.8%
Trash / Recycling-Trash Collection-Missed by Contractor South	28476	1.8%
Solid Waste Customer Service	23091	1.5%
Trash / Recycling-Trash Collection-Missed by Contractor North	22272	1.4%
Streets / Roadways / Alleys-Pothole-District 3	22042	1.4%
Abandoned Vehicle	19023	1.2%
Other values (1226)	1086013	69.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	765661	11.3%
violations	297534	4.4%
property	272148	4.0%
trash	239752	3.5%
by	172991	2.5%
animal	132435	1.9%
water	126206	1.9%
or	121976	1.8%
contractor	119869	1.8%
missed	101448	1.5%
Other values (1269)	4453170	65.5%

Most occurring characters

Value	Count	Frequency (%)
	5240289	10.3%
e	4342352	8.5%
r	3473307	6.8%
t	3409110	6.7%
i	3178178	6.2%
o	2898784	5.7%
a	2854112	5.6%
n	2631165	5.2%
s	2510366	4.9%
l	1989500	3.9%
Other values (63)	18361060	36.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	36579696	71.9%
Uppercase Letter	6621246	13.0%
Space Separator	5240289	10.3%
Dash Punctuation	1431477	2.8%
Other Punctuation	713489	1.4%
Decimal Number	213756	0.4%
Open Punctuation	43303	0.1%
Close Punctuation	42842	0.1%
Math Symbol	2038	< 0.1%
Initial Punctuation	87	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4342352	11.9%
r	3473307	9.5%
t	3409110	9.3%
i	3178178	8.7%
o	2898784	7.9%
a	2854112	7.8%
n	2631165	7.2%
s	2510366	6.9%
l	1989500	5.4%
c	1480628	4.0%
Other values (16)	7812194	21.4%

Uppercase Letter

Value	Count	Frequency (%)
S	843642	12.7%
P	822834	12.4%
R	587903	8.9%
C	583764	8.8%
T	552829	8.3%
A	472383	7.1%
V	373397	5.6%
M	356041	5.4%
W	323551	4.9%
D	309053	4.7%
Other values (15)	1395849	21.1%

Decimal Number

Value	Count	Frequency (%)
1	45085	21.1%
3	42714	20.0%
2	42378	19.8%
7	28431	13.3%
4	27627	12.9%
0	14649	6.9%
5	4530	2.1%
6	2921	1.4%
8	2813	1.3%
9	2608	1.2%

Other Punctuation

Value	Count	Frequency (%)
/	702783	98.5%
&	6604	0.9%
,	3964	0.6%
'	108	< 0.1%
.	30	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	1423974	99.5%
–	7503	0.5%

Space Separator

Value	Count	Frequency (%)
	5240289	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	43303	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	42842	100.0%

Math Symbol

Value	Count	Frequency (%)
+	2038	100.0%

Initial Punctuation

Value	Count	Frequency (%)
‘	87	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	43200942	84.9%
Common	7687281	15.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4342352	10.1%
r	3473307	8.0%
t	3409110	7.9%
i	3178178	7.4%
o	2898784	6.7%
a	2854112	6.6%
n	2631165	6.1%
s	2510366	5.8%
l	1989500	4.6%
c	1480628	3.4%
Other values (41)	14433440	33.4%

Common

Value	Count	Frequency (%)
	5240289	68.2%
-	1423974	18.5%
/	702783	9.1%
1	45085	0.6%
(	43303	0.6%
)	42842	0.6%
3	42714	0.6%
2	42378	0.6%
7	28431	0.4%
4	27627	0.4%
Other values (12)	47855	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	50880633	> 99.9%
Punctuation	7590	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	5240289	10.3%
e	4342352	8.5%
r	3473307	6.8%
t	3409110	6.7%
i	3178178	6.2%
o	2898784	5.7%
a	2854112	5.6%
n	2631165	5.2%
s	2510366	4.9%
l	1989500	3.9%
Other values (61)	18353470	36.1%

Punctuation

Value	Count	Frequency (%)
–	7503	98.9%
‘	87	1.1%

CATEGORY
Categorical

Distinct	84
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

Trash / Recycling	205683
Trash	168125
Property Violations	134094
Animal	98921
Streets / Roadways / Alleys	74919
Other values (79)	881473

Length

Max length	35
Median length	30
Mean length	13.94984
Min length	3

Characters and Unicode

Total characters	21806599
Distinct characters	48
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Property / Buildings / Construction
2nd row	Streets / Roadways / Alleys
3rd row	Property / Buildings / Construction
4th row	Property / Buildings / Construction
5th row	Parks & Recreation

Common Values

Value	Count	Frequency (%)
Trash / Recycling	205683	13.2%
Trash	168125	10.8%
Property Violations	134094	8.6%
Animal	98921	6.3%
Streets / Roadways / Alleys	74919	4.8%
Trees	73966	4.7%
Animals / Pets	73694	4.7%
Property / Buildings / Construction	73234	4.7%
Water Leak	71347	4.6%
Water	56724	3.6%
Other values (74)	532508	34.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	777196	21.6%
trash	373808	10.4%
property	232185	6.5%
recycling	205683	5.7%
violations	199740	5.6%
water	185164	5.2%
animal	98921	2.8%
streets	74919	2.1%
roadways	74919	2.1%
alleys	74919	2.1%
Other values (101)	1295445	36.1%

Most occurring characters

Value	Count	Frequency (%)
	2029684	9.3%
e	1770832	8.1%
r	1514568	6.9%
i	1482107	6.8%
s	1453162	6.7%
a	1415107	6.5%
t	1330280	6.1%
n	1154224	5.3%
o	1090374	5.0%
l	1026372	4.7%
Other values (38)	7539889	34.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	16186973	74.2%
Uppercase Letter	2812746	12.9%
Space Separator	2029684	9.3%
Other Punctuation	777196	3.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1770832	10.9%
r	1514568	9.4%
i	1482107	9.2%
s	1453162	9.0%
a	1415107	8.7%
t	1330280	8.2%
n	1154224	7.1%
o	1090374	6.7%
l	1026372	6.3%
c	727972	4.5%
Other values (14)	3221975	19.9%

Uppercase Letter

Value	Count	Frequency (%)
T	457894	16.3%
P	421154	15.0%
S	333684	11.9%
R	290911	10.3%
A	276437	9.8%
W	261172	9.3%
V	248665	8.8%
L	119789	4.3%
B	100690	3.6%
C	97569	3.5%
Other values (11)	204781	7.3%

Other Punctuation

Value	Count	Frequency (%)
/	719830	92.6%
&	57366	7.4%

Space Separator

Value	Count	Frequency (%)
	2029684	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18999719	87.1%
Common	2806880	12.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1770832	9.3%
r	1514568	8.0%
i	1482107	7.8%
s	1453162	7.6%
a	1415107	7.4%
t	1330280	7.0%
n	1154224	6.1%
o	1090374	5.7%
l	1026372	5.4%
c	727972	3.8%
Other values (35)	6034721	31.8%

Common

Value	Count	Frequency (%)
	2029684	72.3%
/	719830	25.6%
&	57366	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21806599	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2029684	9.3%
e	1770832	8.1%
r	1514568	6.9%
i	1482107	6.8%
s	1453162	6.7%
a	1415107	6.5%
t	1330280	6.1%
n	1154224	5.3%
o	1090374	5.0%
l	1026372	4.7%
Other values (38)	7539889	34.6%

TYPE
Categorical

Distinct	295
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

Private Property	181843
Trash Collection	70001
Property Maintenance	56455
Street	48630
Pothole	39777
Other values (290)	1166509

Length

Max length	48
Median length	29
Mean length	11.899895
Min length	2

Characters and Unicode

Total characters	18602094
Distinct characters	69
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	Dangerous Building
2nd row	Crack
3rd row	Dangerous Building
4th row	Property Maintenance
5th row	Park Maintenance

Common Values

Value	Count	Frequency (%)
Private Property	181843	11.6%
Trash Collection	70001	4.5%
Property Maintenance	56455	3.6%
Street	48630	3.1%
Pothole	39777	2.5%
Recycling	38664	2.5%
Investigations	36064	2.3%
Other	34611	2.2%
Services	31559	2.0%
Administration	30418	1.9%
Other values (285)	995193	63.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
property	246467	9.1%
private	213828	7.9%
	118647	4.4%
street	99068	3.7%
trash	70159	2.6%
collection	70001	2.6%
maintenance	65340	2.4%
animal	52113	1.9%
stray	47867	1.8%
pothole	39777	1.5%
Other values (343)	1683117	62.2%

Most occurring characters

Value	Count	Frequency (%)
e	1934335	10.4%
r	1626910	8.7%
t	1536231	8.3%
a	1346391	7.2%
i	1251603	6.7%
	1143169	6.1%
n	1133790	6.1%
o	1009491	5.4%
l	663892	3.6%
P	578906	3.1%
Other values (59)	6377376	34.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14743571	79.3%
Uppercase Letter	2509188	13.5%
Space Separator	1143169	6.1%
Other Punctuation	125515	0.7%
Decimal Number	54301	0.3%
Dash Punctuation	13999	0.1%
Open Punctuation	6102	< 0.1%
Close Punctuation	6102	< 0.1%
Initial Punctuation	147	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1934335	13.1%
r	1626910	11.0%
t	1536231	10.4%
a	1346391	9.1%
i	1251603	8.5%
n	1133790	7.7%
o	1009491	6.8%
l	663892	4.5%
c	562616	3.8%
y	499008	3.4%
Other values (16)	3179304	21.6%

Uppercase Letter

Value	Count	Frequency (%)
P	578906	23.1%
S	289650	11.5%
C	240537	9.6%
R	183614	7.3%
A	162665	6.5%
B	147822	5.9%
T	145769	5.8%
D	118884	4.7%
L	109082	4.3%
M	108032	4.3%
Other values (15)	424227	16.9%

Decimal Number

Value	Count	Frequency (%)
1	14948	27.5%
2	11371	20.9%
0	8742	16.1%
3	3140	5.8%
6	2923	5.4%
8	2812	5.2%
4	2647	4.9%
7	2619	4.8%
9	2608	4.8%
5	2491	4.6%

Other Punctuation

Value	Count	Frequency (%)
/	116109	92.5%
&	9373	7.5%
.	33	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1143169	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	13999	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	6102	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	6102	100.0%

Initial Punctuation

Value	Count	Frequency (%)
‘	147	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17252759	92.7%
Common	1349335	7.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1934335	11.2%
r	1626910	9.4%
t	1536231	8.9%
a	1346391	7.8%
i	1251603	7.3%
n	1133790	6.6%
o	1009491	5.9%
l	663892	3.8%
P	578906	3.4%
c	562616	3.3%
Other values (41)	5608594	32.5%

Common

Value	Count	Frequency (%)
	1143169	84.7%
/	116109	8.6%
1	14948	1.1%
-	13999	1.0%
2	11371	0.8%
&	9373	0.7%
0	8742	0.6%
(	6102	0.5%
)	6102	0.5%
3	3140	0.2%
Other values (8)	16280	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18601947	> 99.9%
Punctuation	147	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1934335	10.4%
r	1626910	8.7%
t	1536231	8.3%
a	1346391	7.2%
i	1251603	6.7%
	1143169	6.1%
n	1133790	6.1%
o	1009491	5.4%
l	663892	3.6%
P	578906	3.1%
Other values (58)	6377229	34.3%

Punctuation

Value	Count	Frequency (%)
‘	147	100.0%

DETAIL
Categorical

Distinct	574
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

All	426673
Missed	49518
Missed by Contractor North	39989
Missed by Contractor South	39955
Non Emergency	34611
Other values (569)	972469

Length

Max length	48
Median length	31
Mean length	10.467135
Min length	3

Characters and Unicode

Total characters	16362382
Distinct characters	66
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	36 ?
Unique (%)	< 0.1%

Sample

1st row	Standard
2nd row	District 1
3rd row	Standard
4th row	Other Property Issue
5th row	Central

Common Values

Value	Count	Frequency (%)
All	426673	27.3%
Missed	49518	3.2%
Missed by Contractor North	39989	2.6%
Missed by Contractor South	39955	2.6%
Non Emergency	34611	2.2%
*Select one	32305	2.1%
District 3	31905	2.0%
Dead	30393	1.9%
Missed by City	27268	1.7%
Other Property Issue	26124	1.7%
Other values (564)	824474	52.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
all	428758	14.3%
missed	172087	5.8%
	135089	4.5%
by	107464	3.6%
district	107235	3.6%
contractor	89601	3.0%
property	70100	2.3%
south	69653	2.3%
north	60495	2.0%
one	57947	1.9%
Other values (600)	1693151	56.6%

Most occurring characters

Value	Count	Frequency (%)
e	1505379	9.2%
	1428365	8.7%
t	1310932	8.0%
r	1212748	7.4%
l	1087247	6.6%
i	896135	5.5%
o	845654	5.2%
s	787339	4.8%
n	708151	4.3%
a	643131	3.9%
Other values (56)	5937301	36.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11901213	72.7%
Uppercase Letter	2711940	16.6%
Space Separator	1428365	8.7%
Dash Punctuation	114893	0.7%
Other Punctuation	108326	0.7%
Decimal Number	78896	0.5%
Open Punctuation	8339	0.1%
Close Punctuation	8339	0.1%
Math Symbol	2038	< 0.1%
Initial Punctuation	33	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1505379	12.6%
t	1310932	11.0%
r	1212748	10.2%
l	1087247	9.1%
i	896135	7.5%
o	845654	7.1%
s	787339	6.6%
n	708151	6.0%
a	643131	5.4%
c	431294	3.6%
Other values (16)	2473203	20.8%

Uppercase Letter

Value	Count	Frequency (%)
A	510716	18.8%
S	295407	10.9%
M	234827	8.7%
C	234346	8.6%
D	189901	7.0%
P	175668	6.5%
N	159626	5.9%
L	151890	5.6%
O	134016	4.9%
T	120206	4.4%
Other values (15)	505337	18.6%

Decimal Number

Value	Count	Frequency (%)
3	31985	40.5%
1	22084	28.0%
2	20851	26.4%
5	2038	2.6%
4	1938	2.5%

Other Punctuation

Value	Count	Frequency (%)
/	62947	58.1%
*	45286	41.8%
'	64	0.1%
.	29	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1428365	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	114893	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	8339	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	8339	100.0%

Math Symbol

Value	Count	Frequency (%)
+	2038	100.0%

Initial Punctuation

Value	Count	Frequency (%)
‘	33	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14613153	89.3%
Common	1749229	10.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1505379	10.3%
t	1310932	9.0%
r	1212748	8.3%
l	1087247	7.4%
i	896135	6.1%
o	845654	5.8%
s	787339	5.4%
n	708151	4.8%
a	643131	4.4%
A	510716	3.5%
Other values (41)	5105721	34.9%

Common

Value	Count	Frequency (%)
	1428365	81.7%
-	114893	6.6%
/	62947	3.6%
*	45286	2.6%
3	31985	1.8%
1	22084	1.3%
2	20851	1.2%
(	8339	0.5%
)	8339	0.5%
5	2038	0.1%
Other values (5)	4102	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16362349	> 99.9%
Punctuation	33	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1505379	9.2%
	1428365	8.7%
t	1310932	8.0%
r	1212748	7.4%
l	1087247	6.6%
i	896135	5.5%
o	845654	5.2%
s	787339	4.8%
n	708151	4.3%
a	643131	3.9%
Other values (55)	5937268	36.3%

Punctuation

Value	Count	Frequency (%)
‘	33	100.0%

CREATION DATE
Categorical

Distinct	5229
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

01/22/2019	2313
01/24/2019	2130
01/23/2019	1816
01/13/2010	1794
01/14/2010	1762
Other values (5224)	1553400

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	15632150
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	46 ?
Unique (%)	< 0.1%

Sample

1st row	06/24/2019
2nd row	12/22/2019
3rd row	01/19/2021
4th row	11/25/2020
5th row	04/18/2020

Common Values

Value	Count	Frequency (%)
01/22/2019	2313	0.1%
01/24/2019	2130	0.1%
01/23/2019	1816	0.1%
01/13/2010	1794	0.1%
01/14/2010	1762	0.1%
01/17/2019	1656	0.1%
11/28/2018	1646	0.1%
11/27/2018	1453	0.1%
01/25/2019	1448	0.1%
11/29/2018	1424	0.1%
Other values (5219)	1545773	98.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
01/22/2019	2313	0.1%
01/24/2019	2130	0.1%
01/23/2019	1816	0.1%
01/13/2010	1794	0.1%
01/14/2010	1762	0.1%
01/17/2019	1656	0.1%
11/28/2018	1646	0.1%
11/27/2018	1453	0.1%
01/25/2019	1448	0.1%
11/29/2018	1424	0.1%
Other values (5219)	1545773	98.9%

Most occurring characters

Value	Count	Frequency (%)
0	4095304	26.2%
/	3126430	20.0%
2	2700418	17.3%
1	2466958	15.8%
9	566063	3.6%
8	560925	3.6%
7	488082	3.1%
3	450259	2.9%
6	407050	2.6%
5	397145	2.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	12505720	80.0%
Other Punctuation	3126430	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4095304	32.7%
2	2700418	21.6%
1	2466958	19.7%
9	566063	4.5%
8	560925	4.5%
7	488082	3.9%
3	450259	3.6%
6	407050	3.3%
5	397145	3.2%
4	373516	3.0%

Other Punctuation

Value	Count	Frequency (%)
/	3126430	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	15632150	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4095304	26.2%
/	3126430	20.0%
2	2700418	17.3%
1	2466958	15.8%
9	566063	3.6%
8	560925	3.6%
7	488082	3.1%
3	450259	2.9%
6	407050	2.6%
5	397145	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15632150	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4095304	26.2%
/	3126430	20.0%
2	2700418	17.3%
1	2466958	15.8%
9	566063	3.6%
8	560925	3.6%
7	488082	3.1%
3	450259	2.9%
6	407050	2.6%
5	397145	2.5%

CREATION TIME
Categorical

Distinct	1440
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

11:01 AM	2878
10:41 AM	2849
10:43 AM	2826
10:48 AM	2820
10:58 AM	2809
Other values (1435)	1549033

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	12505720
Distinct characters	15
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	07:40 AM
2nd row	07:56 PM
3rd row	02:43 PM
4th row	09:19 AM
5th row	05:10 PM

Common Values

Value	Count	Frequency (%)
11:01 AM	2878	0.2%
10:41 AM	2849	0.2%
10:43 AM	2826	0.2%
10:48 AM	2820	0.2%
10:58 AM	2809	0.2%
09:48 AM	2801	0.2%
10:55 AM	2788	0.2%
10:54 AM	2784	0.2%
10:50 AM	2782	0.2%
10:32 AM	2779	0.2%
Other values (1430)	1535099	98.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pm	879025	28.1%
am	684190	21.9%
11:01	2983	0.1%
10:41	2980	0.1%
09:42	2940	0.1%
09:45	2936	0.1%
10:43	2936	0.1%
10:48	2930	0.1%
09:48	2925	0.1%
09:41	2924	0.1%
Other values (712)	1539661	49.2%

Most occurring characters

Value	Count	Frequency (%)
0	1682522	13.5%
:	1563215	12.5%
	1563215	12.5%
M	1563215	12.5%
1	1182599	9.5%
P	879025	7.0%
2	699543	5.6%
A	684190	5.5%
3	562416	4.5%
4	545820	4.4%
Other values (5)	1579960	12.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6252860	50.0%
Uppercase Letter	3126430	25.0%
Other Punctuation	1563215	12.5%
Space Separator	1563215	12.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1682522	26.9%
1	1182599	18.9%
2	699543	11.2%
3	562416	9.0%
4	545820	8.7%
5	493755	7.9%
9	323319	5.2%
8	304275	4.9%
7	230814	3.7%
6	227797	3.6%

Uppercase Letter

Value	Count	Frequency (%)
M	1563215	50.0%
P	879025	28.1%
A	684190	21.9%

Other Punctuation

Value	Count	Frequency (%)
:	1563215	100.0%

Space Separator

Value	Count	Frequency (%)
	1563215	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	9379290	75.0%
Latin	3126430	25.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1682522	17.9%
:	1563215	16.7%
	1563215	16.7%
1	1182599	12.6%
2	699543	7.5%
3	562416	6.0%
4	545820	5.8%
5	493755	5.3%
9	323319	3.4%
8	304275	3.2%
Other values (2)	458611	4.9%

Latin

Value	Count	Frequency (%)
M	1563215	50.0%
P	879025	28.1%
A	684190	21.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12505720	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1682522	13.5%
:	1563215	12.5%
	1563215	12.5%
M	1563215	12.5%
1	1182599	9.5%
P	879025	7.0%
2	699543	5.6%
A	684190	5.5%
3	562416	4.5%
4	545820	4.4%
Other values (5)	1579960	12.6%

CREATION MONTH
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2869618

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.3485904
Coefficient of variation (CV)	0.53262458
Kurtosis	-1.1016162
Mean	6.2869618
Median Absolute Deviation (MAD)	3
Skewness	0.063491463
Sum	9827873
Variance	11.213058
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	152005	9.7%
6	150000	9.6%
1	143890	9.2%
8	141492	9.1%
7	140286	9.0%
4	131977	8.4%
3	126558	8.1%
9	125359	8.0%
2	121288	7.8%
10	116238	7.4%
Other values (2)	214122	13.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	143890	9.2%
2	121288	7.8%
3	126558	8.1%
4	131977	8.4%
5	152005	9.7%
6	150000	9.6%
7	140286	9.0%
8	141492	9.1%
9	125359	8.0%
10	116238	7.4%

Value	Count	Frequency (%)
12	113909	7.3%
11	100213	6.4%
10	116238	7.4%
9	125359	8.0%
8	141492	9.1%
7	140286	9.0%
6	150000	9.6%
5	152005	9.7%
4	131977	8.4%
3	126558	8.1%

CREATION YEAR
Real number (ℝ)

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.9035

Minimum	2006
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	2006
5-th percentile	2007
Q1	2010
median	2014
Q3	2018
95-th percentile	2020
Maximum	2021
Range	15
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	4.2488245
Coefficient of variation (CV)	0.0021097458
Kurtosis	-1.3473795
Mean	2013.9035
Median Absolute Deviation (MAD)	4
Skewness	-0.074539278
Sum	3.1481642 × 10⁹
Variance	18.05251
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
2019	166021	10.6%
2008	137894	8.8%
2020	125906	8.1%
2018	124280	8.0%
2009	119269	7.6%
2010	110276	7.1%
2017	109811	7.0%
2016	103955	6.7%
2015	96941	6.2%
2011	96113	6.1%
Other values (6)	372749	23.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2006	1	< 0.1%
2007	83075	5.3%
2008	137894	8.8%
2009	119269	7.6%
2010	110276	7.1%
2011	96113	6.1%
2012	90199	5.8%
2013	90462	5.8%
2014	89329	5.7%
2015	96941	6.2%

Value	Count	Frequency (%)
2021	19683	1.3%
2020	125906	8.1%
2019	166021	10.6%
2018	124280	8.0%
2017	109811	7.0%
2016	103955	6.7%
2015	96941	6.2%
2014	89329	5.7%
2013	90462	5.8%
2012	90199	5.8%

STATUS
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

RESOL	1535389
CANC	13818
OPEN	12657
DUP	1301
ASSIG	45

Length

Max length	5
Median length	5
Mean length	4.981396
Min length	3

Characters and Unicode

Total characters	7786993
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RESOL
2nd row	RESOL
3rd row	RESOL
4th row	RESOL
5th row	RESOL

Common Values

Value	Count	Frequency (%)
RESOL	1535389	98.2%
CANC	13818	0.9%
OPEN	12657	0.8%
DUP	1301	0.1%
ASSIG	45	< 0.1%
FAIL	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
resol	1535389	98.2%
canc	13818	0.9%
open	12657	0.8%
dup	1301	0.1%
assig	45	< 0.1%
fail	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	1548046	19.9%
O	1548046	19.9%
S	1535479	19.7%
L	1535394	19.7%
R	1535389	19.7%
C	27636	0.4%
N	26475	0.3%
P	13958	0.2%
A	13868	0.2%
D	1301	< 0.1%
Other values (4)	1401	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7786993	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1548046	19.9%
O	1548046	19.9%
S	1535479	19.7%
L	1535394	19.7%
R	1535389	19.7%
C	27636	0.4%
N	26475	0.3%
P	13958	0.2%
A	13868	0.2%
D	1301	< 0.1%
Other values (4)	1401	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7786993	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1548046	19.9%
O	1548046	19.9%
S	1535479	19.7%
L	1535394	19.7%
R	1535389	19.7%
C	27636	0.4%
N	26475	0.3%
P	13958	0.2%
A	13868	0.2%
D	1301	< 0.1%
Other values (4)	1401	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7786993	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	1548046	19.9%
O	1548046	19.9%
S	1535479	19.7%
L	1535394	19.7%
R	1535389	19.7%
C	27636	0.4%
N	26475	0.3%
P	13958	0.2%
A	13868	0.2%
D	1301	< 0.1%
Other values (4)	1401	< 0.1%

EXCEEDED EST TIMEFRAME
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	23
Missing (%)	< 0.1%
Memory size	3.0 MiB

False	1079493
True	483699
(Missing)	23

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1079493	69.1%
True	483699	30.9%
(Missing)	23	< 0.1%

CLOSED DATE
Categorical

Distinct	4995
Distinct (%)	0.3%
Missing	12702
Missing (%)	0.8%
Memory size	11.9 MiB

09/30/2019	13841
05/05/2014	4595
03/25/2019	3471
02/23/2010	3313
12/03/2018	3281
Other values (4990)	1522012

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	15505130
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	169 ?
Unique (%)	< 0.1%

Sample

1st row	11/19/2021
2nd row	06/26/2020
3rd row	11/15/2021
4th row	04/26/2021
5th row	04/30/2020

Common Values

Value	Count	Frequency (%)
09/30/2019	13841	0.9%
05/05/2014	4595	0.3%
03/25/2019	3471	0.2%
02/23/2010	3313	0.2%
12/03/2018	3281	0.2%
04/05/2019	2863	0.2%
07/29/2009	2764	0.2%
02/14/2019	1988	0.1%
02/13/2019	1838	0.1%
02/21/2019	1794	0.1%
Other values (4985)	1510765	96.6%
(Missing)	12702	0.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
09/30/2019	13841	0.9%
05/05/2014	4595	0.3%
03/25/2019	3471	0.2%
02/23/2010	3313	0.2%
12/03/2018	3281	0.2%
04/05/2019	2863	0.2%
07/29/2009	2764	0.2%
02/14/2019	1988	0.1%
02/13/2019	1838	0.1%
02/21/2019	1794	0.1%
Other values (4985)	1510765	97.4%

Most occurring characters

Value	Count	Frequency (%)
0	4033809	26.0%
/	3101026	20.0%
2	2686065	17.3%
1	2487899	16.0%
9	588607	3.8%
8	528897	3.4%
7	474108	3.1%
3	467330	3.0%
6	397554	2.6%
5	379896	2.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	12404104	80.0%
Other Punctuation	3101026	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4033809	32.5%
2	2686065	21.7%
1	2487899	20.1%
9	588607	4.7%
8	528897	4.3%
7	474108	3.8%
3	467330	3.8%
6	397554	3.2%
5	379896	3.1%
4	359939	2.9%

Other Punctuation

Value	Count	Frequency (%)
/	3101026	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	15505130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4033809	26.0%
/	3101026	20.0%
2	2686065	17.3%
1	2487899	16.0%
9	588607	3.8%
8	528897	3.4%
7	474108	3.1%
3	467330	3.0%
6	397554	2.6%
5	379896	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15505130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4033809	26.0%
/	3101026	20.0%
2	2686065	17.3%
1	2487899	16.0%
9	588607	3.8%
8	528897	3.4%
7	474108	3.1%
3	467330	3.0%
6	397554	2.6%
5	379896	2.5%

CLOSED MONTH
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	26515
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	6.4092647

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.3998366
Coefficient of variation (CV)	0.53045659
Kurtosis	-1.1648866
Mean	6.4092647
Median Absolute Deviation (MAD)	3
Skewness	0.025655982
Sum	9849117
Variance	11.558889
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	139557	8.9%
7	139100	8.9%
5	133823	8.6%
8	133050	8.5%
3	132449	8.5%
1	129537	8.3%
2	128834	8.2%
10	127722	8.2%
9	124401	8.0%
12	122014	7.8%
Other values (2)	226213	14.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	129537	8.3%
2	128834	8.2%
3	132449	8.5%
4	118476	7.6%
5	133823	8.6%
6	139557	8.9%
7	139100	8.9%
8	133050	8.5%
9	124401	8.0%
10	127722	8.2%

Value	Count	Frequency (%)
12	122014	7.8%
11	107737	6.9%
10	127722	8.2%
9	124401	8.0%
8	133050	8.5%
7	139100	8.9%
6	139557	8.9%
5	133823	8.6%
4	118476	7.6%
3	132449	8.5%

CLOSED YEAR
Real number (ℝ)

Distinct	16
Distinct (%)	< 0.1%
Missing	26515
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	2014.0239

Minimum	2007
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	2007
5-th percentile	2008
Q1	2010
median	2014
Q3	2018
95-th percentile	2020
Maximum	2022
Range	15
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	4.2253652
Coefficient of variation (CV)	0.0020979717
Kurtosis	-1.3244347
Mean	2014.0239
Median Absolute Deviation (MAD)	4
Skewness	-0.098468027
Sum	3.0949505 × 10⁹
Variance	17.853711
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
2019	165353	10.6%
2018	123273	7.9%
2008	123016	7.9%
2020	122641	7.8%
2009	119223	7.6%
2017	111686	7.1%
2016	104931	6.7%
2011	101907	6.5%
2010	101188	6.5%
2015	92506	5.9%
Other values (6)	370976	23.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2007	75817	4.9%
2008	123016	7.9%
2009	119223	7.6%
2010	101188	6.5%
2011	101907	6.5%
2012	88661	5.7%
2013	88566	5.7%
2014	91518	5.9%
2015	92506	5.9%
2016	104931	6.7%

Value	Count	Frequency (%)
2022	9	< 0.1%
2021	26405	1.7%
2020	122641	7.8%
2019	165353	10.6%
2018	123273	7.9%
2017	111686	7.1%
2016	104931	6.7%
2015	92506	5.9%
2014	91518	5.9%
2013	88566	5.7%

DAYS TO CLOSE
Real number (ℝ)

MISSING ZEROS

Distinct	2748
Distinct (%)	0.2%
Missing	26515
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	51.533404

Minimum	-21
Maximum	4525
Zeros	150614
Zeros (%)	9.6%
Negative	29
Negative (%)	< 0.1%
Memory size	11.9 MiB

Quantile statistics

Minimum	-21
5-th percentile	0
Q1	1
median	4
Q3	23
95-th percentile	261
Maximum	4525
Range	4546
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	169.57318
Coefficient of variation (CV)	3.2905488
Kurtosis	77.017163
Mean	51.533404
Median Absolute Deviation (MAD)	3
Skewness	7.3881016
Sum	79191382
Variance	28755.063
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	322471	20.6%
0	150614	9.6%
2	120416	7.7%
3	103139	6.6%
4	77824	5.0%
5	57503	3.7%
6	49736	3.2%
7	44990	2.9%
8	31128	2.0%
9	20513	1.3%
Other values (2738)	558366	35.7%
(Missing)	26515	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-21	17	< 0.1%
-20	2	< 0.1%
-19	8	< 0.1%
-18	1	< 0.1%
-1	1	< 0.1%
0	150614	9.6%
1	322471	20.6%
2	120416	7.7%
3	103139	6.6%
4	77824	5.0%

Value	Count	Frequency (%)
4525	1	< 0.1%
4471	1	< 0.1%
4396	1	< 0.1%
4188	1	< 0.1%
4183	1	< 0.1%
4175	1	< 0.1%
4160	1	< 0.1%
4157	1	< 0.1%
4135	1	< 0.1%
4132	1	< 0.1%

STREET ADDRESS
Categorical

Distinct	277728
Distinct (%)	17.8%
Missing	24
Missing (%)	< 0.1%
Memory size	11.9 MiB

414 E 12TH ST	3351
414 E 12th St	2421
4800 E 63rd St	2330
415 E 12th St	1246
415 E 12th st	570
Other values (277723)	1553273

Length

Max length	39
Median length	37
Mean length	15.80865
Min length	4

Characters and Unicode

Total characters	24711939
Distinct characters	75
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	67349 ?
Unique (%)	4.3%

Sample

1st row	2317 E 50th St
2nd row	10329 N Forest Ave
3rd row	2623 E 10th St
4th row	2474 Chelsea Ave
5th row	400 W 31st St

Common Values

Value	Count	Frequency (%)
414 E 12TH ST	3351	0.2%
414 E 12th St	2421	0.2%
4800 E 63rd St	2330	0.1%
415 E 12th St	1246	0.1%
415 E 12th st	570	< 0.1%
400 W 31st St	430	< 0.1%
5100 Wornall Rd	323	< 0.1%
2400 Troost Ave	290	< 0.1%
4900 Raytown Rd	282	< 0.1%
7750 E Front St	269	< 0.1%
Other values (277718)	1551679	99.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ave	602207	10.9%
st	476456	8.6%
e	327586	5.9%
n	180177	3.3%
ter	156915	2.8%
rd	131274	2.4%
ne	112479	2.0%
w	70394	1.3%
blvd	64833	1.2%
nw	64756	1.2%
Other values (12145)	3334294	60.4%

Most occurring characters

Value	Count	Frequency (%)
	3958210	16.0%
1	1284556	5.2%
0	1173280	4.7%
E	1116467	4.5%
e	909295	3.7%
A	892797	3.6%
2	785798	3.2%
t	762941	3.1%
T	726450	2.9%
3	717530	2.9%
Other values (65)	12384615	50.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7637289	30.9%
Decimal Number	7183875	29.1%
Lowercase Letter	5925190	24.0%
Space Separator	3958210	16.0%
Dash Punctuation	5688	< 0.1%
Other Punctuation	1677	< 0.1%
Open Punctuation	5	< 0.1%
Close Punctuation	5	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1116467	14.6%
A	892797	11.7%
T	726450	9.5%
S	694753	9.1%
N	661679	8.7%
R	501664	6.6%
V	331386	4.3%
W	291712	3.8%
L	290404	3.8%
O	286483	3.8%
Other values (16)	1843494	24.1%

Lowercase Letter

Value	Count	Frequency (%)
e	909295	15.3%
t	762941	12.9%
r	482556	8.1%
v	427188	7.2%
n	420855	7.1%
a	372413	6.3%
o	364188	6.1%
l	354868	6.0%
d	338821	5.7%
h	306003	5.2%
Other values (16)	1186062	20.0%

Decimal Number

Value	Count	Frequency (%)
1	1284556	17.9%
0	1173280	16.3%
2	785798	10.9%
3	717530	10.0%
4	714711	9.9%
5	619841	8.6%
6	496732	6.9%
7	496633	6.9%
8	477639	6.6%
9	417155	5.8%

Other Punctuation

Value	Count	Frequency (%)
'	1342	80.0%
,	100	6.0%
.	70	4.2%
/	70	4.2%
#	68	4.1%
&	13	0.8%
"	10	0.6%
:	3	0.2%
%	1	0.1%

Space Separator

Value	Count	Frequency (%)
	3958210	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5688	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	5	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13562479	54.9%
Common	11149460	45.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1116467	8.2%
e	909295	6.7%
A	892797	6.6%
t	762941	5.6%
T	726450	5.4%
S	694753	5.1%
N	661679	4.9%
R	501664	3.7%
r	482556	3.6%
v	427188	3.1%
Other values (42)	6386689	47.1%

Common

Value	Count	Frequency (%)
	3958210	35.5%
1	1284556	11.5%
0	1173280	10.5%
2	785798	7.0%
3	717530	6.4%
4	714711	6.4%
5	619841	5.6%
6	496732	4.5%
7	496633	4.5%
8	477639	4.3%
Other values (13)	424530	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24711939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3958210	16.0%
1	1284556	5.2%
0	1173280	4.7%
E	1116467	4.5%
e	909295	3.7%
A	892797	3.6%
2	785798	3.2%
t	762941	3.1%
T	726450	2.9%
3	717530	2.9%
Other values (65)	12384615	50.1%

ADDRESS WITH GEOCODE
Categorical

Distinct	307249
Distinct (%)	19.7%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

414 E 12th St64106 (39.100387, -94.577919)	2422
414 E 12TH ST64106 (39.100387, -94.577919)	2414
4800 E 63rd St64130 (39.014493, -94.529933)	2330
415 E 12th St64106 (39.099123, -94.577983)	1246
414 E 12TH ST64106 (35.797519, -103.890579)	963
Other values (307244)	1553840

Length

Max length	69
Median length	66
Mean length	44.602594
Min length	19

Characters and Unicode

Total characters	69723444
Distinct characters	73
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	84541 ?
Unique (%)	5.4%

Sample

1st row	2317 E 50th St64130 (39.035489, -94.557309)
2nd row	10329 N Forest Ave64155 (39.28196, -94.564453)
3rd row	2623 E 10th St64127 (39.101272, -94.549951)
4th row	2474 Chelsea Ave64127 (39.079895, -94.526959)
5th row	400 W 31st St64108 (39.074934, -94.591904)

Common Values

Value	Count	Frequency (%)
414 E 12th St64106 (39.100387, -94.577919)	2422	0.2%
414 E 12TH ST64106 (39.100387, -94.577919)	2414	0.2%
4800 E 63rd St64130 (39.014493, -94.529933)	2330	0.1%
415 E 12th St64106 (39.099123, -94.577983)	1246	0.1%
414 E 12TH ST64106 (35.797519, -103.890579)	963	0.1%
415 E 12th st64106 (35.797519, -103.890579)	570	< 0.1%
400 W 31st St64108 (39.074934, -94.591904)	430	< 0.1%
5100 Wornall Rd64112 (39.031378, -94.59448)	323	< 0.1%
7750 E Front St64120 (39.136326, -94.490605)	260	< 0.1%
2400 Troost Ave64108 (39.083166, -94.572049)	259	< 0.1%
Other values (307239)	1551998	99.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
e	327581	3.8%
n	180180	2.1%
ne	112478	1.3%
ave64130	85500	1.0%
w	70398	0.8%
nw	64756	0.7%
ave64127	60184	0.7%
ave64128	46863	0.5%
103.890579	40610	0.5%
35.797519	40597	0.5%
Other values (296654)	7617276	88.1%

Most occurring characters

Value	Count	Frequency (%)
4	5770240	8.3%
	5514815	7.9%
9	5341801	7.7%
1	5255076	7.5%
3	4454744	6.4%
6	3830032	5.5%
5	3688003	5.3%
0	3456592	5.0%
.	3126428	4.5%
2	2886725	4.1%
Other values (63)	26398988	37.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39699460	56.9%
Uppercase Letter	7629706	10.9%
Lowercase Letter	5925053	8.5%
Space Separator	5514815	7.9%
Other Punctuation	4691127	6.7%
Dash Punctuation	1568457	2.2%
Control	1568393	2.2%
Open Punctuation	1563219	2.2%
Close Punctuation	1563214	2.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1115885	14.6%
A	892378	11.7%
T	725629	9.5%
S	694142	9.1%
N	661564	8.7%
R	501575	6.6%
V	331377	4.3%
W	291634	3.8%
L	289072	3.8%
O	286424	3.8%
Other values (16)	1840026	24.1%

Lowercase Letter

Value	Count	Frequency (%)
e	909283	15.3%
t	762909	12.9%
r	482551	8.1%
v	427187	7.2%
n	420848	7.1%
a	372405	6.3%
o	364182	6.1%
l	354864	6.0%
d	338815	5.7%
h	305998	5.2%
Other values (16)	1186011	20.0%

Decimal Number

Value	Count	Frequency (%)
4	5770240	14.5%
9	5341801	13.5%
1	5255076	13.2%
3	4454744	11.2%
6	3830032	9.6%
5	3688003	9.3%
0	3456592	8.7%
2	2886725	7.3%
8	2653764	6.7%
7	2362483	6.0%

Other Punctuation

Value	Count	Frequency (%)
.	3126428	66.6%
,	1563343	33.3%
'	1342	< 0.1%
&	11	< 0.1%
#	2	< 0.1%
%	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	5514815	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1568457	100.0%

Control

Value	Count	Frequency (%)
	1568393	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1563219	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1563214	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	56168685	80.6%
Latin	13554759	19.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1115885	8.2%
e	909283	6.7%
A	892378	6.6%
t	762909	5.6%
T	725629	5.4%
S	694142	5.1%
N	661564	4.9%
R	501575	3.7%
r	482551	3.6%
v	427187	3.2%
Other values (42)	6381656	47.1%

Common

Value	Count	Frequency (%)
4	5770240	10.3%
	5514815	9.8%
9	5341801	9.5%
1	5255076	9.4%
3	4454744	7.9%
6	3830032	6.8%
5	3688003	6.6%
0	3456592	6.2%
.	3126428	5.6%
2	2886725	5.1%
Other values (11)	12844229	22.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	69723444	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	5770240	8.3%
	5514815	7.9%
9	5341801	7.7%
1	5255076	7.5%
3	4454744	6.4%
6	3830032	5.5%
5	3688003	5.3%
0	3456592	5.0%
.	3126428	4.5%
2	2886725	4.1%
Other values (63)	26398988	37.9%

ZIP CODE
Real number (ℝ)

Distinct	65
Distinct (%)	< 0.1%
Missing	826
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	64126.843

Minimum	4114
Maximum	66203
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	4114
5-th percentile	64109
Q1	64116
median	64128
Q3	64133
95-th percentile	64155
Maximum	66203
Range	62089
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	68.122948
Coefficient of variation (CV)	0.0010623156
Kurtosis	721225.59
Mean	64126.843
Median Absolute Deviation (MAD)	9
Skewness	-832.06849
Sum	1.0019107 × 10¹¹
Variance	4640.7361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
64130	133154	8.5%
64127	90867	5.8%
64114	83166	5.3%
64134	77097	4.9%
64131	76437	4.9%
64132	76361	4.9%
64128	73073	4.7%
64110	64771	4.1%
64119	57224	3.7%
64111	50195	3.2%
Other values (55)	780044	49.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4114	1	< 0.1%
6152	1	< 0.1%
63130	1	< 0.1%
64012	39	< 0.1%
64028	22	< 0.1%
64030	27	< 0.1%
64052	47	< 0.1%
64053	115	< 0.1%
64055	28	< 0.1%
64068	280	< 0.1%

Value	Count	Frequency (%)
66203	1	< 0.1%
64444	15	< 0.1%
64167	194	< 0.1%
64166	460	< 0.1%
64165	486	< 0.1%
64164	522	< 0.1%
64163	1160	0.1%
64161	1936	0.1%
64160	89	< 0.1%
64158	6892	0.4%

NEIGHBORHOOD
Categorical

HIGH CARDINALITY MISSING

Distinct	250
Distinct (%)	< 0.1%
Missing	46106
Missing (%)	2.9%
Memory size	11.9 MiB

Shoal Creek	55839
Blue Hills	31462
East Community Team South	21706
Scarritt Point	21295
South Indian Mound	20710
Other values (245)	1366097

Length

Max length	42
Median length	29
Mean length	14.972397
Min length	2

Characters and Unicode

Total characters	22714758
Distinct characters	60
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Blue Hills
2nd row	New Mark
3rd row	Independence Plaza
4th row	East Community Team South
5th row	Westside South

Common Values

Value	Count	Frequency (%)
Shoal Creek	55839	3.6%
Blue Hills	31462	2.0%
East Community Team South	21706	1.4%
Scarritt Point	21295	1.4%
South Indian Mound	20710	1.3%
Lykins	20441	1.3%
Tower Homes	20031	1.3%
CBD Downtown	18486	1.2%
North Indian Mound	17872	1.1%
Swope Parkway-Elmwood	17792	1.1%
Other values (240)	1271475	81.3%
(Missing)	46106	2.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
park	147748	4.3%
hills	128098	3.7%
east	108867	3.2%
creek	104581	3.0%
blue	98087	2.8%
south	98018	2.8%
north	94066	2.7%
and	77209	2.2%
shoal	59166	1.7%
oak	59067	1.7%
Other values (269)	2476354	71.8%

Most occurring characters

Value	Count	Frequency (%)
e	2024521	8.9%
	1934152	8.5%
a	1649498	7.3%
o	1561057	6.9%
r	1370100	6.0%
t	1291903	5.7%
l	1174709	5.2%
n	1168235	5.1%
s	1134269	5.0%
i	1065864	4.7%
Other values (50)	8340450	36.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	17008571	74.9%
Uppercase Letter	3515573	15.5%
Space Separator	1934152	8.5%
Decimal Number	140924	0.6%
Dash Punctuation	82454	0.4%
Other Punctuation	33084	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2024521	11.9%
a	1649498	9.7%
o	1561057	9.2%
r	1370100	8.1%
t	1291903	7.6%
l	1174709	6.9%
n	1168235	6.9%
s	1134269	6.7%
i	1065864	6.3%
h	746484	4.4%
Other values (15)	3821931	22.5%

Uppercase Letter

Value	Count	Frequency (%)
S	367459	10.5%
C	360417	10.3%
H	349438	9.9%
P	322701	9.2%
W	224225	6.4%
M	205260	5.8%
E	203178	5.8%
B	195938	5.6%
N	186385	5.3%
R	155777	4.4%
Other values (13)	944795	26.9%

Decimal Number

Value	Count	Frequency (%)
6	37402	26.5%
9	25165	17.9%
4	25165	17.9%
3	25165	17.9%
2	13161	9.3%
7	10056	7.1%
1	2405	1.7%
8	2405	1.7%

Other Punctuation

Value	Count	Frequency (%)
/	19923	60.2%
&	13161	39.8%

Space Separator

Value	Count	Frequency (%)
	1934152	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	82454	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	20524144	90.4%
Common	2190614	9.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2024521	9.9%
a	1649498	8.0%
o	1561057	7.6%
r	1370100	6.7%
t	1291903	6.3%
l	1174709	5.7%
n	1168235	5.7%
s	1134269	5.5%
i	1065864	5.2%
h	746484	3.6%
Other values (38)	7337504	35.8%

Common

Value	Count	Frequency (%)
	1934152	88.3%
-	82454	3.8%
6	37402	1.7%
9	25165	1.1%
4	25165	1.1%
3	25165	1.1%
/	19923	0.9%
2	13161	0.6%
&	13161	0.6%
7	10056	0.5%
Other values (2)	4810	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	22714758	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2024521	8.9%
	1934152	8.5%
a	1649498	7.3%
o	1561057	6.9%
r	1370100	6.0%
t	1291903	5.7%
l	1174709	5.2%
n	1168235	5.1%
s	1134269	5.0%
i	1065864	4.7%
Other values (50)	8340450	36.7%

COUNTY
Categorical

IMBALANCE MISSING

Distinct	13
Distinct (%)	< 0.1%
Missing	66959
Missing (%)	4.3%
Memory size	11.9 MiB

Jackson	1165976
Clay	248388
Platte	80799
CLAY	573
Cass	228
Other values (8)	292

Length

Max length	13
Median length	7
Mean length	6.4463307
Min length	4

Characters and Unicode

Total characters	9645361
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Jackson
2nd row	Clay
3rd row	Jackson
4th row	Jackson
5th row	Jackson

Common Values

Value	Count	Frequency (%)
Jackson	1165976	74.6%
Clay	248388	15.9%
Platte	80799	5.2%
CLAY	573	< 0.1%
Cass	228	< 0.1%
JACKSON	219	< 0.1%
jackson	41	< 0.1%
clay	23	< 0.1%
platte	4	< 0.1%
Platte County	2	< 0.1%
Other values (3)	3	< 0.1%
(Missing)	66959	4.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
jackson	1166236	77.9%
clay	248984	16.6%
platte	80806	5.4%
cass	228	< 0.1%
county	2	< 0.1%
clayl	1	< 0.1%
ackson	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	1495463	15.5%
s	1166474	12.1%
J	1166195	12.1%
c	1166041	12.1%
o	1166020	12.1%
n	1166020	12.1%
k	1166018	12.1%
l	329218	3.4%
C	249411	2.6%
y	248414	2.6%
Other values (16)	326087	3.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8146132	84.5%
Uppercase Letter	1499227	15.5%
Space Separator	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1495463	18.4%
s	1166474	14.3%
c	1166041	14.3%
o	1166020	14.3%
n	1166020	14.3%
k	1166018	14.3%
l	329218	4.0%
y	248414	3.0%
t	161612	2.0%
e	80805	1.0%
Other values (3)	47	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
J	1166195	77.8%
C	249411	16.6%
P	80802	5.4%
A	793	0.1%
L	574	< 0.1%
Y	573	< 0.1%
K	219	< 0.1%
S	219	< 0.1%
O	219	< 0.1%
N	219	< 0.1%
Other values (2)	3	< 0.1%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9645359	> 99.9%
Common	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1495463	15.5%
s	1166474	12.1%
J	1166195	12.1%
c	1166041	12.1%
o	1166020	12.1%
n	1166020	12.1%
k	1166018	12.1%
l	329218	3.4%
C	249411	2.6%
y	248414	2.6%
Other values (15)	326085	3.4%

Common

Value	Count	Frequency (%)
	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9645361	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1495463	15.5%
s	1166474	12.1%
J	1166195	12.1%
c	1166041	12.1%
o	1166020	12.1%
n	1166020	12.1%
k	1166018	12.1%
l	329218	3.4%
C	249411	2.6%
y	248414	2.6%
Other values (16)	326087	3.4%

COUNCIL DISTRICT
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	35242
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	3.7171017

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	4
Q3	5
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.5887064
Coefficient of variation (CV)	0.42740462
Kurtosis	-0.99747228
Mean	3.7171017
Median Absolute Deviation (MAD)	1
Skewness	-0.19876216
Sum	5679631
Variance	2.5239881
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	365648	23.4%
5	313864	20.1%
4	269603	17.2%
6	243506	15.6%
1	196785	12.6%
2	138567	8.9%
(Missing)	35242	2.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	196785	12.6%
2	138567	8.9%
3	365648	23.4%
4	269603	17.2%
5	313864	20.1%
6	243506	15.6%

Value	Count	Frequency (%)
6	243506	15.6%
5	313864	20.1%
4	269603	17.2%
3	365648	23.4%
2	138567	8.9%
1	196785	12.6%

POLICE DISTRICT
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	35265
Missing (%)	2.3%
Memory size	11.9 MiB

Metro	383130
East	374326
Central	234327
Shoal Creek	209760
South	201792

Length

Max length	11
Median length	7
Mean length	5.8854269
Min length	4

Characters and Unicode

Total characters	8992638
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Metro
2nd row	Shoal Creek
3rd row	East
4th row	East
5th row	Central

Common Values

Value	Count	Frequency (%)
Metro	383130	24.5%
East	374326	23.9%
Central	234327	15.0%
Shoal Creek	209760	13.4%
South	201792	12.9%
North	124615	8.0%
(Missing)	35265	2.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
metro	383130	22.0%
east	374326	21.5%
central	234327	13.5%
shoal	209760	12.1%
creek	209760	12.1%
south	201792	11.6%
north	124615	7.2%

Most occurring characters

Value	Count	Frequency (%)
t	1318190	14.7%
e	1036977	11.5%
r	951832	10.6%
o	919297	10.2%
a	818413	9.1%
h	536167	6.0%
C	444087	4.9%
l	444087	4.9%
S	411552	4.6%
M	383130	4.3%
Other values (7)	1728906	19.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7045168	78.3%
Uppercase Letter	1737710	19.3%
Space Separator	209760	2.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	1318190	18.7%
e	1036977	14.7%
r	951832	13.5%
o	919297	13.0%
a	818413	11.6%
h	536167	7.6%
l	444087	6.3%
s	374326	5.3%
n	234327	3.3%
k	209760	3.0%

Uppercase Letter

Value	Count	Frequency (%)
C	444087	25.6%
S	411552	23.7%
M	383130	22.0%
E	374326	21.5%
N	124615	7.2%

Space Separator

Value	Count	Frequency (%)
	209760	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8782878	97.7%
Common	209760	2.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	1318190	15.0%
e	1036977	11.8%
r	951832	10.8%
o	919297	10.5%
a	818413	9.3%
h	536167	6.1%
C	444087	5.1%
l	444087	5.1%
S	411552	4.7%
M	383130	4.4%
Other values (6)	1519146	17.3%

Common

Value	Count	Frequency (%)
	209760	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8992638	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	1318190	14.7%
e	1036977	11.5%
r	951832	10.6%
o	919297	10.2%
a	818413	9.1%
h	536167	6.0%
C	444087	4.9%
l	444087	4.9%
S	411552	4.6%
M	383130	4.3%
Other values (7)	1728906	19.2%

PARCEL ID NO
Real number (ℝ)

SKEWED ZEROS

Distinct	175953
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	106754.49

Minimum	0
Maximum	9.9589235 × 10⁸
Zeros	35266
Zeros (%)	2.3%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	0
5-th percentile	3898
Q1	38358
median	85391
Q3	136854
95-th percentile	228308
Maximum	9.9589235 × 10⁸
Range	9.9589235 × 10⁸
Interquartile range (IQR)	98496

Descriptive statistics

Standard deviation	2353178.5
Coefficient of variation (CV)	22.042899
Kurtosis	76590.509
Mean	106754.49
Median Absolute Deviation (MAD)	49221
Skewness	250.90887
Sum	1.6688022 × 10¹¹
Variance	5.5374489 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	35266	2.3%
12614	4942	0.3%
492	2754	0.2%
12926	1265	0.1%
128568	542	< 0.1%
99048	520	< 0.1%
98624	450	< 0.1%
142693	433	< 0.1%
12635	414	< 0.1%
127254	360	< 0.1%
Other values (175943)	1516269	97.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35266	2.3%
1	28	< 0.1%
5	13	< 0.1%
6	1	< 0.1%
7	142	< 0.1%
10	30	< 0.1%
12	23	< 0.1%
14	3	< 0.1%
17	72	< 0.1%
18	42	< 0.1%

Value	Count	Frequency (%)
995892354	1	< 0.1%
935159351	1	< 0.1%
675192432	4	< 0.1%
673306734	1	< 0.1%
672126721	1	< 0.1%
647706478	1	< 0.1%
647476476	1	< 0.1%
620486201	1	< 0.1%
485674857	1	< 0.1%
250613250	3	< 0.1%

LATITUDE
Real number (ℝ)

Distinct	157747
Distinct (%)	10.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.985272

Minimum	35.797519
Maximum	39.35464
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	35.797519
5-th percentile	38.915251
Q1	38.997002
median	39.054552
Q3	39.109302
95-th percentile	39.257015
Maximum	39.35464
Range	3.557121
Interquartile range (IQR)	0.1123

Descriptive statistics

Standard deviation	0.52951741
Coefficient of variation (CV)	0.013582499
Kurtosis	31.132856
Mean	38.985272
Median Absolute Deviation (MAD)	0.056051
Skewness	-5.6446435
Sum	60942361
Variance	0.28038868
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35.797519	40610	2.6%
39.100387	4940	0.3%
39.014493	2469	0.2%
39.099123	1246	0.1%
39.074934	476	< 0.1%
39.285963	380	< 0.1%
39.031378	374	< 0.1%
39.100349	371	< 0.1%
39.307933	360	< 0.1%
39.074825	312	< 0.1%
Other values (157737)	1511677	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
35.797519	40610	2.6%
38.827084	1	< 0.1%
38.83482	5	< 0.1%
38.835025	6	< 0.1%
38.838219	29	< 0.1%
38.838324	5	< 0.1%
38.838331	34	< 0.1%
38.838343	3	< 0.1%
38.838587	8	< 0.1%
38.838841	4	< 0.1%

Value	Count	Frequency (%)
39.35464	5	< 0.1%
39.354635	2	< 0.1%
39.354631	1	< 0.1%
39.354629	6	< 0.1%
39.354601	3	< 0.1%
39.354591	5	< 0.1%
39.354575	16	< 0.1%
39.353859	1	< 0.1%
39.353853	3	< 0.1%
39.353638	1	< 0.1%

LONGITUDE
Real number (ℝ)

Distinct	126281
Distinct (%)	8.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-94.792875

Minimum	-103.89058
Maximum	-94.386375
Zeros	0
Zeros (%)	0.0%
Negative	1563215
Negative (%)	100.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	-103.89058
5-th percentile	-94.645131
Q1	-94.583575
median	-94.55375
Q3	-94.523262
95-th percentile	-94.474424
Maximum	-94.386375
Range	9.504204
Interquartile range (IQR)	0.060313

Descriptive statistics

Standard deviation	1.4864643
Coefficient of variation (CV)	-0.015681181
Kurtosis	33.45319
Mean	-94.792875
Median Absolute Deviation (MAD)	0.030071
Skewness	-5.9512036
Sum	-1.4818164 × 10⁸
Variance	2.209576
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-103.890579	40610	2.6%
-94.577919	4958	0.3%
-94.529933	2472	0.2%
-94.577983	1246	0.1%
-94.591904	481	< 0.1%
-94.576776	414	< 0.1%
-94.472954	378	< 0.1%
-94.540878	372	< 0.1%
-94.59448	370	< 0.1%
-94.588552	320	< 0.1%
Other values (126271)	1511594	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-103.890579	40610	2.6%
-94.756681	1	< 0.1%
-94.756298	1	< 0.1%
-94.754146	1	< 0.1%
-94.752204	1	< 0.1%
-94.752202	1	< 0.1%
-94.752171	12	< 0.1%
-94.75217	2	< 0.1%
-94.752163	8	< 0.1%
-94.752122	2	< 0.1%

Value	Count	Frequency (%)
-94.386375	26	< 0.1%
-94.386377	2	< 0.1%
-94.386465	1	< 0.1%
-94.386516	13	< 0.1%
-94.386648	12	< 0.1%
-94.386673	1	< 0.1%
-94.386677	8	< 0.1%
-94.386711	3	< 0.1%
-94.386814	2	< 0.1%
-94.386906	2	< 0.1%

CASE URL
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	1563215
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019119972	1
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015045877	1
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015040302	1
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015041682	1
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015049038	1
Other values (1563210)	1563210

Length

Max length	91
Median length	75
Mean length	75.007103
Min length	75

Characters and Unicode

Total characters	117252229
Distinct characters	43
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1563215 ?
Unique (%)	100.0%

Sample

1st row	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019119972
2nd row	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019207923
3rd row	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2021005976
4th row	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2020149407
5th row	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2020054721

Common Values

Value	Count	Frequency (%)
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019119972	1	< 0.1%
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015045877	1	< 0.1%
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015040302	1	< 0.1%
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015041682	1	< 0.1%
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015049038	1	< 0.1%
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015034811	1	< 0.1%
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015041579	1	< 0.1%
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015042453	1	< 0.1%
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015052481	1	< 0.1%
http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015043953	1	< 0.1%
Other values (1563205)	1563205	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2019119972	1	< 0.1%
http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2019208975	1	< 0.1%
http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2020054721	1	< 0.1%
http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2019182182	1	< 0.1%
http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2019184705	1	< 0.1%
http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2019184590	1	< 0.1%
http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2020095175	1	< 0.1%
http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2015094486	1	< 0.1%
http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2020021142	1	< 0.1%
http://city.kcmo.org/kc/actioncenterrequest/caseinfo.aspx?caseid=2020086645	1	< 0.1%
Other values (1563205)	1563205	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
e	9379984	8.0%
t	9378596	8.0%
/	7816075	6.7%
o	6254942	5.3%
s	6254248	5.3%
c	6252860	5.3%
n	4691033	4.0%
a	4689645	4.0%
.	4689645	4.0%
C	4689645	4.0%
Other values (33)	53155556	45.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	71918994	61.3%
Other Punctuation	15632150	13.3%
Decimal Number	15632150	13.3%
Uppercase Letter	12505720	10.7%
Math Symbol	1563215	1.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	9379984	13.0%
t	9378596	13.0%
o	6254942	8.7%
s	6254248	8.7%
c	6252860	8.7%
n	4691033	6.5%
a	4689645	6.5%
p	3127124	4.3%
i	3127124	4.3%
r	3126430	4.3%
Other values (13)	15637008	21.7%

Decimal Number

Value	Count	Frequency (%)
0	3757171	24.0%
2	2729759	17.5%
1	2605774	16.7%
9	1022088	6.5%
8	999282	6.4%
3	946917	6.1%
7	941128	6.0%
5	883944	5.7%
4	881469	5.6%
6	864618	5.5%

Uppercase Letter

Value	Count	Frequency (%)
C	4689645	37.5%
I	3126430	25.0%
D	1563215	12.5%
R	1563215	12.5%
A	1563215	12.5%

Other Punctuation

Value	Count	Frequency (%)
/	7816075	50.0%
.	4689645	30.0%
?	1563215	10.0%
:	1563215	10.0%

Math Symbol

Value	Count	Frequency (%)
=	1563215	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	84424714	72.0%
Common	32827515	28.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	9379984	11.1%
t	9378596	11.1%
o	6254942	7.4%
s	6254248	7.4%
c	6252860	7.4%
n	4691033	5.6%
a	4689645	5.6%
C	4689645	5.6%
p	3127124	3.7%
i	3127124	3.7%
Other values (18)	26579513	31.5%

Common

Value	Count	Frequency (%)
/	7816075	23.8%
.	4689645	14.3%
0	3757171	11.4%
2	2729759	8.3%
1	2605774	7.9%
=	1563215	4.8%
?	1563215	4.8%
:	1563215	4.8%
9	1022088	3.1%
8	999282	3.0%
Other values (5)	4518076	13.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	117252229	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	9379984	8.0%
t	9378596	8.0%
/	7816075	6.7%
o	6254942	5.3%
s	6254248	5.3%
c	6252860	5.3%
n	4691033	4.0%
a	4689645	4.0%
.	4689645	4.0%
C	4689645	4.0%
Other values (33)	53155556	45.3%

30-60-90 Days Open Window
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	1550513
Missing (%)	99.2%
Memory size	11.9 MiB

0.0	7388
90.0	4597
30.0	415
60.0	302

Length

Max length	4
Median length	3
Mean length	3.4183593
Min length	3

Characters and Unicode

Total characters	43420
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	7388	0.5%
90.0	4597	0.3%
30.0	415	< 0.1%
60.0	302	< 0.1%
(Missing)	1550513	99.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	7388	58.2%
90.0	4597	36.2%
30.0	415	3.3%
60.0	302	2.4%

Most occurring characters

Value	Count	Frequency (%)
0	25404	58.5%
.	12702	29.3%
9	4597	10.6%
3	415	1.0%
6	302	0.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	30718	70.7%
Other Punctuation	12702	29.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	25404	82.7%
9	4597	15.0%
3	415	1.4%
6	302	1.0%

Other Punctuation

Value	Count	Frequency (%)
.	12702	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	43420	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	25404	58.5%
.	12702	29.3%
9	4597	10.6%
3	415	1.0%
6	302	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43420	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	25404	58.5%
.	12702	29.3%
9	4597	10.6%
3	415	1.0%
6	302	0.7%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	CASE ID	SOURCE	DEPARTMENT	WORK GROUP	REQUEST TYPE	CATEGORY	TYPE	DETAIL	CREATION DATE	CREATION TIME	CREATION MONTH	CREATION YEAR	STATUS	EXCEEDED EST TIMEFRAME	CLOSED DATE	CLOSED MONTH	CLOSED YEAR	DAYS TO CLOSE	STREET ADDRESS	ADDRESS WITH GEOCODE	ZIP CODE	NEIGHBORHOOD	COUNTY	COUNCIL DISTRICT	POLICE DISTRICT	PARCEL ID NO	LATITUDE	LONGITUDE	CASE URL	30-60-90 Days Open Window
0	2019119972	PHONE	NHS	NHS-Dangerous Buildings-	Prop/Build/Construct-Dangerous Building-On list	Property / Buildings / Construction	Dangerous Building	Standard	06/24/2019	07:40 AM	6	2019	RESOL	Y	11/19/2021	11.0	2021.0	879.0	2317 E 50th St	2317 E 50th St64130\n(39.035489, -94.557309)	64130.0	Blue Hills	Jackson	3.0	Metro	138863	39.035489	-94.557309	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019119972	NaN
1	2019207923	WEB	Public Works	Public Works-Street and Traffic-District 1	Streets / Roadways / Alleys-Crack-District 1	Streets / Roadways / Alleys	Crack	District 1	12/22/2019	07:56 PM	12	2019	RESOL	Y	06/26/2020	6.0	2020.0	187.0	10329 N Forest Ave	10329 N Forest Ave64155\n(39.28196, -94.564453)	64155.0	New Mark	Clay	2.0	Shoal Creek	103703	39.281960	-94.564453	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019207923	NaN
2	2021005976	PHONE	NHS	NHS-Dangerous Buildings-	Prop/Build/Construct-Dangerous Building-On list	Property / Buildings / Construction	Dangerous Building	Standard	01/19/2021	02:43 PM	1	2021	RESOL	Y	11/15/2021	11.0	2021.0	300.0	2623 E 10th St	2623 E 10th St64127\n(39.101272, -94.549951)	64127.0	Independence Plaza	Jackson	3.0	East	10703	39.101272	-94.549951	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2021005976	NaN
3	2020149407	PHONE	NHS	NHS-Neighborhood Preservation-	Property Violations	Property / Buildings / Construction	Property Maintenance	Other Property Issue	11/25/2020	09:19 AM	11	2020	RESOL	Y	04/26/2021	4.0	2021.0	152.0	2474 Chelsea Ave	2474 Chelsea Ave64127\n(39.079895, -94.526959)	64127.0	East Community Team South	Jackson	3.0	East	19178	39.079895	-94.526959	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2020149407	NaN
4	2020054721	WEB	Parks and Rec	Parks and Rec-Central Region-	Parks & Recreation-Park Maintenance-Central	Parks & Recreation	Park Maintenance	Central	04/18/2020	05:10 PM	4	2020	RESOL	N	04/30/2020	4.0	2020.0	12.0	400 W 31st St	400 W 31st St64108\n(39.074934, -94.591904)	64108.0	Westside South	Jackson	4.0	Central	128568	39.074934	-94.591904	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2020054721	NaN
5	2019182182	PHONE	NHS	NHS-Dangerous Buildings-	Prop/Build/Construct-Dangerous Building-On list	Property / Buildings / Construction	Dangerous Building	Standard	10/21/2019	10:29 AM	10	2019	RESOL	Y	08/03/2020	8.0	2020.0	287.0	4043 Kenwood Ave	4043 Kenwood Ave64110\n(39.052983, -94.577808)	64110.0	South Hyde Park	Jackson	4.0	Central	133291	39.052983	-94.577808	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019182182	NaN
6	2019184705	WEB	NHS	NHS-Solid Waste-	Trash / Recycling-Recycling-Missed by City	Trash / Recycling	Recycling	Missed by City	10/25/2019	10:02 AM	10	2019	RESOL	N	10/28/2019	10.0	2019.0	3.0	637 E 62nd St	637 E 62nd St64110\n(39.01416, -94.579673)	64110.0	Western 49-63	Jackson	6.0	Metro	106106	39.014160	-94.579673	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019184705	NaN
7	2019184590	WEB	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Trees-Trimming-Tree Limbs	Trees	Trimming	Tree Limbs	10/25/2019	04:44 AM	10	2019	RESOL	Y	12/04/2019	12.0	2019.0	40.0	10901 Blue Ridge Blvd	10901 Blue Ridge Blvd64134\n(38.924085, -94.507192)	64134.0	Ruskin Heights	Jackson	6.0	South	59546	38.924085	-94.507192	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019184590	NaN
8	2020095175	PHONE	NHS	NHS-Dangerous Buildings-	Prop/Build/Construct-Dangerous Building-On list	Property / Buildings / Construction	Dangerous Building	Standard	07/13/2020	08:00 AM	7	2020	RESOL	Y	11/29/2021	11.0	2021.0	504.0	4215 E 60th St	4215 E 60th St64130\n(39.016565, -94.536611)	64130.0	Swope Parkway-Elmwood	Jackson	5.0	Metro	326	39.016565	-94.536611	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2020095175	NaN
9	2015094486	PHONE	NHS	NHS-Solid Waste-Administration	Trash / Recycling-Services-Service Issue / Problem	Trash / Recycling	Services	Service Issue / Problem	08/07/2015	01:45 PM	8	2015	RESOL	Y	05/27/2016	5.0	2016.0	294.0	4518 N Askew Ave	4518 N Askew Ave64117\n(39.176846, -94.537416)	64117.0	Antioch Acres	Clay	1.0	Shoal Creek	76946	39.176846	-94.537416	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2015094486	NaN

	CASE ID	SOURCE	DEPARTMENT	WORK GROUP	REQUEST TYPE	CATEGORY	TYPE	DETAIL	CREATION DATE	CREATION TIME	CREATION MONTH	CREATION YEAR	STATUS	EXCEEDED EST TIMEFRAME	CLOSED DATE	CLOSED MONTH	CLOSED YEAR	DAYS TO CLOSE	STREET ADDRESS	ADDRESS WITH GEOCODE	ZIP CODE	NEIGHBORHOOD	COUNTY	COUNCIL DISTRICT	POLICE DISTRICT	PARCEL ID NO	LATITUDE	LONGITUDE	CASE URL	30-60-90 Days Open Window
1563205	2019175846	PHONE	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Trees-Removal-Declining	Trees	Removal	Declining	10/04/2019	11:35 AM	10	2019	RESOL	Y	12/04/2019	12.0	2019.0	61.0	3942 Wyandotte St	3942 Wyandotte St64111\n(39.055001, -94.588843)	64111.0	Old Westport	Jackson	4.0	Central	132644	39.055001	-94.588843	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019175846	NaN
1563206	2019175727	PHONE	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Trees-Removal-Tree Limbs	Trees	Removal	Tree Limbs	10/04/2019	09:32 AM	10	2019	RESOL	Y	11/05/2019	11.0	2019.0	32.0	9014 E 88th Ter	9014 E 88th Ter64138\n(38.962712, -94.478245)	64138.0	White Oak	Jackson	5.0	South	66408	38.962712	-94.478245	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019175727	NaN
1563207	2019176019	PHONE	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Trees-Trimming-Block Pruning	Trees	Trimming	Block Pruning	10/04/2019	03:51 PM	10	2019	RESOL	N	10/11/2019	10.0	2019.0	7.0	9208 NE 109th Ct	9208 NE 109th Ct64157\n(39.289643, -94.46439)	64157.0	Shoal Creek	Clay	1.0	Shoal Creek	209678	39.289643	-94.464390	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019176019	NaN
1563208	2019175967	PHONE	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Trees-Trimming-Tree Limbs	Trees	Trimming	Tree Limbs	10/04/2019	02:46 PM	10	2019	RESOL	Y	10/30/2019	10.0	2019.0	26.0	3106 Peery Ave	3106 Peery Ave64127\n(39.099803, -94.545545)	64127.0	Independence Plaza	Jackson	3.0	East	10876	39.099803	-94.545545	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019175967	NaN
1563209	2019175920	PHONE	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Trees-Trimming-Tree Limbs	Trees	Trimming	Tree Limbs	10/04/2019	01:04 PM	10	2019	RESOL	Y	10/19/2019	10.0	2019.0	15.0	5048 NE 56th Pl	5048 NE 56th Pl64119\n(39.195871, -94.518434)	64119.0	Ravenwood-Somerset	Clay	1.0	Shoal Creek	90408	39.195871	-94.518434	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019175920	NaN
1563210	2019175624	PHONE	NHS	NHS-Solid Waste-	Trash / Recycling-Trash Collection-Missed by Contractor North	Trash / Recycling	Trash Collection	Missed by Contractor North	10/03/2019	06:18 PM	10	2019	RESOL	N	10/05/2019	10.0	2019.0	2.0	10415 NW 87th St	10415 NW 87th St64153\n(39.251356, -94.702155)	64153.0	KCI & 2nd Creek	Platte	2.0	North	211724	39.251356	-94.702155	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019175624	NaN
1563211	2019176099	PHONE	Parks and Rec	Parks and Rec-Central Region-	Parks & Recreation-Park Maintenance-Central	Parks & Recreation	Park Maintenance	Central	10/05/2019	08:13 AM	10	2019	RESOL	N	10/10/2019	10.0	2019.0	5.0	2308 Topping Ave	2308 Topping Ave64127\n(39.082634, -94.515668)	64127.0	South Blue Valley	Jackson	3.0	East	20118	39.082634	-94.515668	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019176099	NaN
1563212	2019176030	PHONE	NHS	NHS-Solid Waste-	Animals / Pets-Dead Animal -Curb	Animals / Pets	Dead Animal	Curb	10/04/2019	04:07 PM	10	2019	RESOL	N	10/05/2019	10.0	2019.0	1.0	5437 South Benton Ave	5437 South Benton Ave64130\n(39.026897, -94.551349)	64130.0	North Town Fork Creek	Jackson	5.0	Metro	36265	39.026897	-94.551349	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019176030	NaN
1563213	2019176115	PHONE	Public Works	Public Works-Capital Projects-Traffic Permits	Streets / Roadways / Alleys-Plate-Missing / Displaced	Streets / Roadways / Alleys	Plate	Missing / Displaced	10/05/2019	04:50 PM	10	2019	RESOL	Y	12/04/2019	12.0	2019.0	60.0	1201 W 75th St	1201 W 75th St64114\n(38.992568, -94.604029)	64114.0	Ward Parkway	Jackson	6.0	Metro	120444	38.992568	-94.604029	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019176115	NaN
1563214	2019172858	WEB	City Planning and Development	City Planning and Development-Permit Compliance-	Prop/Build/Construct-Construction Issue/Concern-Work without permit	Property / Buildings / Construction	Construction Issue/Concern	Work Without Permit	09/27/2019	08:01 PM	9	2019	RESOL	Y	10/06/2019	10.0	2019.0	9.0	10799 NW Skyview Ave	10799 NW Skyview Ave64154\n(39.288525, -94.651254)	64154.0	KCI & 2nd Creek	Platte	2.0	North	207756	39.288525	-94.651254	http://city.kcmo.org/kc/ActionCenterRequest/CaseInfo.aspx?CaseID=2019172858	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Dash Punctuation

Space Separator

Open Punctuation

Close Punctuation

Math Symbol

Initial Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Punctuation

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator